#region Copyright (C) 2007 Jens Winter

//Copyright (C) 2007 Jens Winter

//This library is free software; you can redistribute it and/or
//modify it under the terms of the GNU Lesser General Public
//License as published by the Free Software Foundation; either
//version 2.1 of the License, or (at your option) any later version.

//This library is distributed in the hope that it will be useful,
//but WITHOUT ANY WARRANTY; without even the implied warranty of
//MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
//Lesser General Public License for more details.

//You should have received a copy of the GNU Lesser General Public
//License along with this library; if not, write to the Free Software
//Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA

#endregion

using System;
using System.Collections.Generic;
using System.Data;
using Flynn.Core.ActivityResults;

namespace Flynn.Core.Activities
{
    public class ExecuteSqlStatementsActivity : IExecuteSqlStatementsActivity
    {
        private readonly IExecuteSqlStatementActivity _executeSqlStatementActivity;

        public ExecuteSqlStatementsActivity(IExecuteSqlStatementActivity executeSqlStatementActivity)
        {
            if (executeSqlStatementActivity == null)
                throw new ArgumentNullException("executeSqlStatementActivity");

            _executeSqlStatementActivity = executeSqlStatementActivity;
        }

        public ExecuteSqlStatementsResult ExecuteSqlStatements(IList<string> sqlStatements, IDbConnection connection)
        {
            if (sqlStatements == null)
                throw new ArgumentNullException("sqlStatements");

            if (connection == null)
                throw new ArgumentNullException("connection");

            try
            {
                foreach (string sqlStatement in sqlStatements)
                {
                    ExecuteSqlStatementResult executeSqlStatementResult = _executeSqlStatementActivity.ExecuteSqlStatement(sqlStatement, connection);
                    if (executeSqlStatementResult.Failed)
                        return ExecuteSqlStatementsResult.Failure(executeSqlStatementResult.FailureMessage);
                }

                return ExecuteSqlStatementsResult.Success();
            }
            catch (Exception e)
            {
                return ExecuteSqlStatementsResult.Failure(e.Message);
            }
        }
    }
}